package dao;

import pojo.Room;
import java.util.List;

public interface RoomDao {
    // 插入房间信息
    int insertRoom(Room room);
    
    // 根据房间ID删除房间
    int deleteRoomById(int roomId);
    
    // 更新房间信息
    int updateRoom(Room room);
    
    // 根据房间ID查询房间
    Room selectRoomById(int roomId);
    
    // 查询所有房间
    List<Room> selectAllRooms();
    
    // 根据科室ID查询房间
    List<Room> selectRoomsByDepartmentId(int departmentId);
    List<Room> selectRoomsByDepartmentId(Integer departmentId);
    // 根据楼层查询房间
    List<Room> selectRoomsByFloor(int floor);
} 